Lotus 1-2-3 keyboard equivalents

Lotus 1-2-3	Microsoft Excel
F1 (Help)	F1
F2 (Edit)	F2
F3 (Name)	F3
F4 (Absolute/relative)	F4
F5 (Go to)	F5
F6 (Next window)	CTRL+F6
F7 (Query)	Use the AutoFilter command (Data menu) to find rows in a range or list: Press ALT, D, F, F to filter the range or list. Use the arrow keys to select the cell that contains the column label, and then press ALT+DOWN ARROW, select a value in the AutoFilter list, and press ENTER.
F8 (Data table)	Tables recalculate automatically, unless you select the Automatic except tables check box on the Calculation tab (Tools menu, Options command). If this option is set, you can manually recalculate data tables by pressing F9.
F9 (Calculate)	F9
F10 (Graph)	F11 or ALT+F1

Lotus 1-2-3	Microsoft Excel
Up, Down	UP ARROW, DOWN ARROW
Left, Right	LEFT ARROW, RIGHT ARROW
End, Up	CTRL+UP ARROW or END+UP ARROW
End, Down	CTRL+DOWN ARROW or END+DOWN ARROW
End, Left	CTRL+LEFT ARROW or END+LEFT ARROW
End, Right	CTRL+RIGHT ARROW or END+RIGHT ARROW
Home	CTRL+HOME
Tab	CTRL+PAGE DOWN
Shift+Tab	CTRL+PAGE UP
PgUp, PgDn	PAGE UP or PAGE DOWN

These navigation keys can be used to make the transition between Lotus 1-2-3 and Microsoft Excel. To select transition navigation keys, press ALT+T and then press O (Tools menu, Options command), press CTRL+TAB to select the Transition tab, and then press ALT+K to select the Transition navigation keys check box.

Press	To move
SHIFT+TAB or CTRL+LEFT ARROW	One screen to the left
TAB or CTRL+RIGHT ARROW	One screen to the right
CTRL+PAGE DOWN	To the next sheet in a workbook
CTRL+PAGE UP	To the previous sheet in a workbook
HOME	To the first cell on the sheet (the cell in the upper-left corner)

Use the following text-alignment prefix characters to assign alignment formats as you enter data in cells.

Press	To
' (apostrophe)	Left align data in the cell
" (quotation mark)	Right align data in the cell
^ (caret)	Center data within the cell
\ (backslash)	Repeat characters across the cell